[dbo].[BAEImisOrdersGetAllByUser]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisOrdersGetAllByUser

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@USER_ID	varchar(16)	16

SQL Script

create procedure [dbo].[BAEImisOrdersGetAllByUser] @USER_ID as
varchar(16)
AS
    SELECT *
    FROM Orders
    WHERE ST_ID         =    @USER_ID
    ORDER BY ORDER_NUMBER DESC;

GO

Uses

[dbo].[Orders]
dbo